﻿CREATE TABLE [Common].[MediaEmbed]
(
	[MediaEmbedID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [COMMON_MediaEmbed_MediaEmbedID] PRIMARY KEY,	
	[Content] NVARCHAR(255) NOT NULL DEFAULT 'NONE', 
	[Width] INT NOT NULL DEFAULT 0, 
	[Height] INT NOT NULL DEFAULT 0, 
	[Scrolling] BIT NOT NULL DEFAULT 'False',
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [COMMON_MediaEmbed_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [COMMON_MediaEmbed_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [COMMON_MediaEmbed_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [COMMON_MediaEmbed_VersionDate] DEFAULT GETDATE()
)
